<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>wwwApp: database/db.php Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td style="padding-left: 0.5em;">
   <div id="projectname">wwwApp
   </div>
   <div id="projectbrief">A web app for workshop organizing, recruitment and qualification</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.1.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>File&#160;Members</span></a></li>
    </ul>
  </div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div id="nav-path" class="navpath">
  <ul>
<li class="navelem"><a class="el" href="dir_f32c53f2c0f0ccaeb11076e30674d5f4.html">database</a></li>  </ul>
</div>
</div><!-- top -->
<div class="header">
  <div class="headertitle">
<div class="title">db.php</div>  </div>
</div><!--header-->
<div class="contents">
<a href="db_8php.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;&lt;?php</div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment">/*</span></div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment"> *      database/db.php</span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment"> */</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;</div>
<div class="line"><a name="l00006"></a><span class="lineno"><a class="code" href="classDB.html">    6</a></span>&#160;<span class="keyword">abstract</span> <span class="keyword">class </span><a class="code" href="classDB.html">DB</a></div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;{</div>
<div class="line"><a name="l00008"></a><span class="lineno"><a class="code" href="classDB.html#ab6ce44bdfbaf5904efd9597447543782">    8</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="classDB.html#ab6ce44bdfbaf5904efd9597447543782">$lastResult</a> = null;</div>
<div class="line"><a name="l00009"></a><span class="lineno"><a class="code" href="classDB.html#a818dededd3464b586037fde8ef953c91">    9</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="classDB.html#a818dededd3464b586037fde8ef953c91">$driver</a>;</div>
<div class="line"><a name="l00010"></a><span class="lineno"><a class="code" href="classDB.html#a75d8342d237a97b7822d691aa5a2546c">   10</a></span>&#160;        <span class="keyword">protected</span> <a class="code" href="classDB.html#a75d8342d237a97b7822d691aa5a2546c">$tables</a> = array();</div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;</div>
<div class="line"><a name="l00012"></a><span class="lineno"><a class="code" href="classDB.html#aebc4d944d05977ab3fc55d910bec39a4">   12</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">function</span> <a class="code" href="classDB.html#aebc4d944d05977ab3fc55d910bec39a4">create</a>(<a class="code" href="classDB.html#a818dededd3464b586037fde8ef953c91">$driver</a>, $connectionString)</div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;        {</div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;                require_once(strtolower(<a class="code" href="classDB.html#a818dededd3464b586037fde8ef953c91">$driver</a>) .<span class="stringliteral">&#39;.php&#39;</span>);</div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;                $className = <span class="stringliteral">&quot;DB_$driver&quot;</span>;</div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;                <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a> = <span class="keyword">new</span> $className($connectionString);</div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;                <span class="keywordflow">return</span> <a class="code" href="common_8php.html#a7dc56dc8b18ad37272b56fa7395bedef">$DB</a>;</div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;        }</div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;</div>
<div class="line"><a name="l00020"></a><span class="lineno"><a class="code" href="classDB.html#aaf7049cc36effb73ddfbc2636667d02c">   20</a></span>&#160;        <span class="keyword">protected</span> <span class="keyword">function</span> <a class="code" href="classDB.html#aaf7049cc36effb73ddfbc2636667d02c">__construct</a>($connectionString)</div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;        {</div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;                <span class="keywordflow">if</span> (!$this-&gt;<a class="code" href="classDB.html#a031c0b13b6803f486c377a4c98774f4d">connect</a>($connectionString))</div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;                        <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classKnownException.html">KnownException</a>(_(<span class="stringliteral">&#39;Could not connect to database.&#39;</span>). <span class="stringliteral">&#39;&lt;br/&gt;</span></div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="stringliteral">                        &lt;pre&gt;&#39;</span>. $this-&gt;<a class="code" href="classDB.html#a73cdc78a3b878af16d7163bfb01f4d2c">last_error</a>() .<span class="stringliteral">&#39;&lt;/pre&gt;&#39;</span>);</div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;        }</div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;        <span class="keyword">abstract</span> <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a031c0b13b6803f486c377a4c98774f4d">connect</a>($connectionString);</div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;</div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;        <span class="keyword">abstract</span> <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a73cdc78a3b878af16d7163bfb01f4d2c">last_error</a>();</div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;</div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;        <span class="comment">// Enable &quot; $DB-&gt;tablename : DBTable &quot; syntax.</span></div>
<div class="line"><a name="l00031"></a><span class="lineno"><a class="code" href="classDB.html#af448d1613ece8e2da7aec313e034dda6">   31</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> &amp;<a class="code" href="classDB.html#af448d1613ece8e2da7aec313e034dda6">__get</a>($name)</div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;        {</div>
<div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;                $table = <a class="code" href="config_8php_8template.html#a5f2257735345fb41d6dbb3f7a9036a4b">TABLE_PREFIX</a> . $name;</div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;                <span class="keywordflow">if</span> (isset($this-&gt;tables[$table]) &amp;&amp; is_object($this-&gt;tables[$table]))</div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;                        <span class="keywordflow">return</span> $this-&gt;tables[$table];</div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;                <span class="keywordflow">else</span></div>
<div class="line"><a name="l00037"></a><span class="lineno">   37</span>&#160;                        <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classKnownException.html">KnownException</a>(sprintf(_(<span class="stringliteral">&#39;Undefined database table &lt;i&gt;%s&lt;/i&gt; (prefix is &lt;i&gt;%s&lt;/i&gt;).&#39;</span>), $name, <a class="code" href="config_8php_8template.html#a5f2257735345fb41d6dbb3f7a9036a4b">TABLE_PREFIX</a>));</div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;        }</div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;</div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;        <span class="comment">// Enable &quot; $DB-&gt;tablename($pkey_col1, $pkey_col2) : DBRow &quot; syntax</span></div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;        <span class="comment">// TODO replace array parameter with func_get_args().</span></div>
<div class="line"><a name="l00042"></a><span class="lineno"><a class="code" href="classDB.html#abd238125cc5e22cc83461af76e535db5">   42</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#abd238125cc5e22cc83461af76e535db5">__call</a>($name, $args)</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;        {</div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;                        <span class="keywordflow">return</span> $this-&gt;{$name}-&gt;offsetGet($args);</div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;        }</div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;</div>
<div class="line"><a name="l00047"></a><span class="lineno"><a class="code" href="classDB.html#a27e743626280f0e9cba228a8d9343d3d">   47</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a27e743626280f0e9cba228a8d9343d3d">num_rows</a>()  { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;count(); }</div>
<div class="line"><a name="l00048"></a><span class="lineno"><a class="code" href="classDB.html#a946b17452055bacf43cae40100565566">   48</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a946b17452055bacf43cae40100565566">affected_rows</a>()  { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;affected_rows(); }</div>
<div class="line"><a name="l00049"></a><span class="lineno"><a class="code" href="classDB.html#ae314c1807aa636e83084e7f776df8ca5">   49</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#ae314c1807aa636e83084e7f776df8ca5">fetch</a>()         { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;fetch(); }</div>
<div class="line"><a name="l00050"></a><span class="lineno"><a class="code" href="classDB.html#ace53342d5a272275e9a95b151511d179">   50</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#ace53342d5a272275e9a95b151511d179">fetch_assoc</a>($n = null) { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;fetch_assoc($n); }</div>
<div class="line"><a name="l00051"></a><span class="lineno"><a class="code" href="classDB.html#a24e5e9e3745e28578179ab3a6169b80c">   51</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a24e5e9e3745e28578179ab3a6169b80c">fetch_all</a>() { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;fetch_all(); }</div>
<div class="line"><a name="l00052"></a><span class="lineno"><a class="code" href="classDB.html#a2284276ef8e3be156cd57d6be193ff4c">   52</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a2284276ef8e3be156cd57d6be193ff4c">fetch_column</a>($c = null) { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;fetch_column($c); }</div>
<div class="line"><a name="l00053"></a><span class="lineno"><a class="code" href="classDB.html#a0ea6b9f5f21f19ae1e6f334b86c37e67">   53</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a0ea6b9f5f21f19ae1e6f334b86c37e67">fetch_int</a>()     { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;fetch_int(); }</div>
<div class="line"><a name="l00054"></a><span class="lineno"><a class="code" href="classDB.html#a8e61ac6b0aceea9beed7e06b867fbf6d">   54</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDB.html#a8e61ac6b0aceea9beed7e06b867fbf6d">fetch_vector</a>()  { <span class="keywordflow">return</span> $this-&gt;lastResult-&gt;fetch_vector(); }</div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;}</div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;</div>
<div class="line"><a name="l00057"></a><span class="lineno"><a class="code" href="classDBTable.html">   57</a></span>&#160;<span class="keyword">abstract</span> <span class="keyword">class </span><a class="code" href="classDBTable.html">DBTable</a> <span class="keyword">implements</span> ArrayAccess</div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;{</div>
<div class="line"><a name="l00059"></a><span class="lineno"><a class="code" href="classDBTable.html#aa22b7d9a7c16da9ffa682910b4b133bf">   59</a></span>&#160;        <span class="keyword">protected</span> <a class="code" href="classDBTable.html#aa22b7d9a7c16da9ffa682910b4b133bf">$DB</a>;</div>
<div class="line"><a name="l00060"></a><span class="lineno"><a class="code" href="classDBTable.html#a7f790eef26347965576a6cae76d95066">   60</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="classDBTable.html#a7f790eef26347965576a6cae76d95066">$name</a>;</div>
<div class="line"><a name="l00061"></a><span class="lineno"><a class="code" href="classDBTable.html#a26400dd6bfdc798587df3610d43f2ed2">   61</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="classDBTable.html#a26400dd6bfdc798587df3610d43f2ed2">$pkeyColumns</a>;</div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;</div>
<div class="line"><a name="l00063"></a><span class="lineno"><a class="code" href="classDBTable.html#abe8e520a4d16c2ec841550a161957a3d">   63</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDBTable.html#abe8e520a4d16c2ec841550a161957a3d">__construct</a>(<a class="code" href="classDBTable.html#aa22b7d9a7c16da9ffa682910b4b133bf">$DB</a>, <a class="code" href="classDBTable.html#a7f790eef26347965576a6cae76d95066">$name</a>, <a class="code" href="classDBTable.html#a26400dd6bfdc798587df3610d43f2ed2">$pkeyColumns</a>)</div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;        {</div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;                $this-&gt;<a class="code" href="classDB.html">DB</a> = <a class="code" href="classDBTable.html#aa22b7d9a7c16da9ffa682910b4b133bf">$DB</a>;</div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;                $this-&gt;name = <a class="code" href="classDBTable.html#a7f790eef26347965576a6cae76d95066">$name</a>;</div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;                $this-&gt;pkeyColumns = <a class="code" href="classDBTable.html#a26400dd6bfdc798587df3610d43f2ed2">$pkeyColumns</a>;</div>
<div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;        }</div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;</div>
<div class="line"><a name="l00070"></a><span class="lineno"><a class="code" href="classDBTable.html#a35016787bba9998dcd3f49ffa0270373">   70</a></span>&#160;        <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="classDBTable.html#a35016787bba9998dcd3f49ffa0270373">offsetGet</a>($pkey)</div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;        {</div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;                <span class="keywordflow">if</span> (count($this-&gt;pkeyColumns) == 0)</div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;                        <span class="keywordflow">throw</span> <span class="keyword">new</span> <a class="code" href="classKnownException.html">KnownException</a>(<span class="stringliteral">&#39;Relation \&#39;&#39;</span>. $this-&gt;name .<span class="charliteral">&#39;\&#39;</span> has no primary key.<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;<span class="stringliteral">                $class = &#39;</span>DBRow_<span class="stringliteral">&#39;. $this-&gt;DB-&gt;driver;</span></div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;<span class="stringliteral">                return new $class($this-&gt;DB, $this, $pkey);</span></div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00078"></a><span class="lineno"><a class="code" href="classDBTable.html#a56c6b0f4f3ad37d6a012005c5fa5a08d">   78</a></span>&#160;<span class="stringliteral">        public function offsetExists($pkey)  { return $this-&gt;offsetGet($pkey)-&gt;count() &gt; 0; }</span></div>
<div class="line"><a name="l00079"></a><span class="lineno"><a class="code" href="classDBTable.html#af7610b2ff8c2adfc14c2fc3f69e25494">   79</a></span>&#160;<span class="stringliteral">        public function offsetUnset($pkey)   { return $this-&gt;offsetGet($pkey)-&gt;delete(); }</span></div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160;<span class="stringliteral">        abstract public function lastValue($column = null);</span></div>
<div class="line"><a name="l00082"></a><span class="lineno">   82</span>&#160;<span class="stringliteral">}</span></div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00086"></a><span class="lineno"><a class="code" href="classDBRow.html">   86</a></span>&#160;<span class="stringliteral">abstract class DBRow implements Countable</span></div>
<div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;<span class="stringliteral">{</span></div>
<div class="line"><a name="l00088"></a><span class="lineno"><a class="code" href="classDBRow.html#a98e301684fcc344986381cf9ddca5427">   88</a></span>&#160;<span class="stringliteral">        protected $DB;</span></div>
<div class="line"><a name="l00089"></a><span class="lineno"><a class="code" href="classDBRow.html#a99cddaa560e2333383ec825573c6efc7">   89</a></span>&#160;<span class="stringliteral">        protected $table;</span></div>
<div class="line"><a name="l00090"></a><span class="lineno"><a class="code" href="classDBRow.html#ad6cdbc83696adfe876d2bf1812534051">   90</a></span>&#160;<span class="stringliteral">        protected $pkey;</span></div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00092"></a><span class="lineno"><a class="code" href="classDBRow.html#abaecd0701cbefa2a324fe2d9f73d545d">   92</a></span>&#160;<span class="stringliteral">        public function __construct($DB, $table, $pkey)</span></div>
<div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;<span class="stringliteral">                $this-&gt;DB = $DB;</span></div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;<span class="stringliteral">                $this-&gt;table = $table;</span></div>
<div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;<span class="stringliteral">                $this-&gt;pkey = $pkey;</span></div>
<div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00099"></a><span class="lineno"><a class="code" href="classDBRow.html#abdcc2f95d94b3d44726075909ba69d2f">   99</a></span>&#160;<span class="stringliteral">        public function get($column)</span></div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;<span class="stringliteral">                $tmp = $this-&gt;assoc($column);</span></div>
<div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;<span class="stringliteral">                return $tmp[$column];</span></div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;<span class="stringliteral">        abstract public function assoc($columns=&#39;</span>*<span class="stringliteral">&#39;);</span></div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;<span class="stringliteral">        abstract public function update($values);</span></div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;<span class="stringliteral">        abstract public function delete();</span></div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;<span class="stringliteral">}</span></div>
<div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00112"></a><span class="lineno"><a class="code" href="classDBResult.html">  112</a></span>&#160;<span class="stringliteral">abstract class DBResult implements Iterator, Countable</span></div>
<div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;<span class="stringliteral">{</span></div>
<div class="line"><a name="l00114"></a><span class="lineno"><a class="code" href="classDBResult.html#af3f8b2a7d0016fb9479da02a018b2044">  114</a></span>&#160;<span class="stringliteral">        public $resultResource = null;</span></div>
<div class="line"><a name="l00115"></a><span class="lineno"><a class="code" href="classDBResult.html#a672dee4bc8dada3fecf2b4f306ece3ef">  115</a></span>&#160;<span class="stringliteral">        protected $DB = null;</span></div>
<div class="line"><a name="l00116"></a><span class="lineno"><a class="code" href="classDBResult.html#a19568f26e9c48c53ec54d68697338412">  116</a></span>&#160;<span class="stringliteral">        public function __construct($DB, $resultResource)</span></div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;<span class="stringliteral">                $this-&gt;DB = $DB;</span></div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;<span class="stringliteral">                $this-&gt;resultResource = $resultResource;</span></div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;<span class="stringliteral">        abstract public function fetch($n = null);</span></div>
<div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;<span class="stringliteral">        abstract public function fetch_assoc($n = null);</span></div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;<span class="stringliteral">        abstract public function fetch_vector($n = null);</span></div>
<div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;<span class="stringliteral">        abstract public function fetch_all();</span></div>
<div class="line"><a name="l00126"></a><span class="lineno"><a class="code" href="classDBResult.html#ab6e8be6e7a71b0ddf01facfd6d0694ff">  126</a></span>&#160;<span class="stringliteral">        public function fetch_column($column = null)</span></div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;<span class="stringliteral">                $all = $this-&gt;fetch_all();</span></div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;<span class="stringliteral">                $result = array();</span></div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;<span class="stringliteral">                if (empty($all))</span></div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;<span class="stringliteral">                        return $result;</span></div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;<span class="stringliteral">                if (is_null($column))</span></div>
<div class="line"><a name="l00133"></a><span class="lineno">  133</span>&#160;<span class="stringliteral">                {</span></div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;<span class="stringliteral">                        $column = array_keys($all[0]);</span></div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;<span class="stringliteral">                        $column = $column[0];</span></div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;<span class="stringliteral">                }</span></div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;<span class="stringliteral">                foreach ($all as $row)</span></div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;<span class="stringliteral">                        $result[]= $row[$column];</span></div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;<span class="stringliteral">                return $result;</span></div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;<span class="stringliteral"></span></div>
<div class="line"><a name="l00142"></a><span class="lineno"><a class="code" href="classDBResult.html#abce0b9c7276aab683d8a962b6d0bd9e8">  142</a></span>&#160;<span class="stringliteral">        public function fetch_int()</span></div>
<div class="line"><a name="l00143"></a><span class="lineno">  143</span>&#160;<span class="stringliteral">        {</span></div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;<span class="stringliteral">                $r = $this-&gt;fetch();</span></div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;<span class="stringliteral">                if (ctype_digit($r))</span></div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;<span class="stringliteral">                        return intval($r);</span></div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;<span class="stringliteral">                else</span></div>
<div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;<span class="stringliteral">                        return false;</span></div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;<span class="stringliteral">        }</span></div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;<span class="stringliteral">}</span></div>
</div><!-- fragment --></div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/><address class="footer"><small>
Generated on Sun Sep 8 2013 17:44:56 for wwwApp by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.8.1.1
</small></address>
</body>
</html>
